// 带客户分类
const {DataTypes, db } = require("../db");
db.define('vContact', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
name:{type: DataTypes.STRING(150),allowNull:false,comment:''}, 
code:{type: DataTypes.STRING(20),comment:''}, 
categoryId:{type: DataTypes.INTEGER,comment:''}, 
contactCatId:{type: DataTypes.INTEGER,comment:''}, 
contactCatCode:{type: DataTypes.STRING(255),comment:''}, 
contactCatName:{type: DataTypes.STRING(20),comment:''}, 
categoryName:{type: DataTypes.STRING(20),comment:''}, 
linkName:{type: DataTypes.STRING(50),comment:''}, 
linkMobile:{type: DataTypes.STRING(50),comment:''}, 
linkPhone:{type: DataTypes.STRING(50),comment:''}, 
address:{type: DataTypes.STRING(255),comment:''}, 
areaId:{type: DataTypes.INTEGER,comment:''}, 
areaName:{type: DataTypes.STRING(100),allowNull:false,comment:''}, 
isCustomer:{type: DataTypes.INTEGER,comment:''}, 
isProvider:{type: DataTypes.INTEGER,comment:''}, 
payType:{type: DataTypes.STRING(22),comment:''}, 
distance:{type: DataTypes.DECIMAL(20, 2),comment:''}, 
printTitle:{type: DataTypes.STRING(255),allowNull:false,comment:''}, 
printBar:{type: DataTypes.INTEGER,comment:''}, 
printCodeBar:{type: DataTypes.INTEGER,comment:''}, 
printPhone:{type: DataTypes.STRING(255),allowNull:false,comment:''}, 
remark:{type: DataTypes.STRING(250),comment:''}, 
isDel:{type: DataTypes.INTEGER,comment:''}, 
canLogin:{type: DataTypes.INTEGER,comment:''}, 
imgUrl:{type: DataTypes.STRING(255),comment:''}, 
longitude:{type: DataTypes.STRING(255),comment:''}, 
latitude:{type: DataTypes.STRING(255),comment:''}, 
cby:{type: DataTypes.INTEGER,comment:''}, 
ctime:{type: DataTypes.STRING(20),comment:''}, 

}, {
    tableName: 'v_contact',
    timestamps: false,
    comment: '带客户分类',
    
});